Returns or sets a value that determines if the properties that set the current data point are incremented during data entry without manually setting the Column and Row properties.
Syntax
object.AutoIncrement [ = boolean]
The AutoIncrement property syntax has these parts:
| Part | Description |
| object | An object expression that evaluates to an object in the Applies To list. |
| boolean | A Boolean expression that specifies whether the current data point is incremented, as described in Settings. |
Settings
The settings for boolean are:
| Setting | Description |
| True | When the Data property is changed, the Row property updates to the next row in the column. If you are at the end of a column, the Column property increments to the next column. |
| False | (Default) The current data point is not incremented. |